Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
INVOLV_SID | NUMBER(38) | No | null | 12 | null | NO | NO | NO |
IS_PRI_SUBJECT | VARCHAR2(1) | Yes | null | 13 | null | NO | NO | NO |
OBJ | VARCHAR2(20) | No | null | 1 | null | NO | NO | NO |
PARTIC_OBJ | VARCHAR2(20) | No | null | 2 | null | NO | NO | NO |
USAGE | VARCHAR2(100) | No | null | 3 | null | NO | NO | NO |
CODE | VARCHAR2(50) | No | null | 4 | null | NO | NO | NO |
ROLE_DISPLAY | VARCHAR2(100) | No | null | 5 | null | NO | NO | NO |
ROLE_ACTIVE | VARCHAR2(1) | No | null | 6 | null | NO | NO | NO |
PARTIC_DISPLAY | VARCHAR2(400) | Yes | null | 7 | null | NO | NO | NO |
PARTIC_OBJ_TYPE_CODE | VARCHAR2(51) | No | null | 8 | null | NO | NO | NO |
PARTIC_OBJ_TYPE_DISP | VARCHAR2(100) | No | null | 9 | null | NO | NO | NO |
PARTICIPANT_NAME | VARCHAR2(400) | Yes | null | 10 | null | NO | NO | NO |
OFFICE | VARCHAR2(4000) | Yes | null | 11 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_SIII_COLL_INVESTIGATIONS | VIEW | QART | V_OBJ_PARTICIPANTS | VIEW |
QART | V_SIII_INVESTIGATIONS | VIEW | QART | V_OBJ_PARTICIPANTS | VIEW |
QART | V_SIIC_INTAKE | VIEW | QART | V_OBJ_PARTICIPANTS | VIEW |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | V_OBJ_PARTICIPANTS | VIEW |
QART | V_CUBE_SIII_INVESTIGATIONS | VIEW | QART | V_OBJ_PARTICIPANTS | VIEW |
QART | V_ALL_ALLEGATIONS | VIEW | QART | V_OBJ_PARTICIPANTS | VIEW |
QART | V_SIIC_THREAT_INV | VIEW | QART | V_OBJ_PARTICIPANTS | VIEW |
QART | MV_ALL_ALLEGATIONS | MATERIALIZED VIEW | QART | V_OBJ_PARTICIPANTS | VIEW |
QART | V_CUBE_TIMES_INVESTIGATIONS | VIEW | QART | V_OBJ_PARTICIPANTS | VIEW |
References
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE_REF | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE_REF | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE_REF | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE_REF | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE_REF | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE_REF | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE_REF | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE_REF | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INDIV_OFFICE_REF | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | V_OBJ_PARTICIPANTS | VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
NAME | VALUE |
---|---|
CREATED | 10-APR-23 |
LAST_DDL_TIME | 05-FEB-25 |
OWNER | QART |
VIEW_NAME | V_OBJ_PARTICIPANTS |
TEXT_LENGTH | 744 |
TEXT | SELECT I.OBJ, I.PARTICIPANT PARTIC_OBJ, T.USAGE, T.CODE, T.DISPLAY ROLE_DISPLAY, T.ACTIVE ROLE_ACTIVE, O.TAGLINE PARTIC_DISPLAY, OT.OBJ_TYPE_CODE PARTIC_OBJ_TYPE_CODE, OT.DISPLAY PARTIC_OBJ_TYPE_DISP, O.TAGLINE PARTICIPANT_NAME, TPIOR.DISPLAY OFFICE, I.SID INVOLV_SID, I.IS_PRI_SUBJECT FROM MV_PARTIC_INVOLVEMENT I INNER JOIN MV_PARTIC_ROLE_TYPE T ON I.INVOLVEMENT_ROLE = T.SID INNER JOIN MV_ACM_OBJ O ON I.PARTICIPANT = O.SID INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID LEFT JOIN MV_PARTIC_INDIV_OFFICE TPIO ON TPIO.SID = I.INDIV_OFFICE LEFT JOIN MV_PARTIC_INDIV_OFFICE_REF TPIOR ON TPIOR.REF_KEY = TPIO.OFFICE |
TEXT_VC | SELECT I.OBJ, I.PARTICIPANT PARTIC_OBJ, T.USAGE, T.CODE, T.DISPLAY ROLE_DISPLAY, T.ACTIVE ROLE_ACTIVE, O.TAGLINE PARTIC_DISPLAY, OT.OBJ_TYPE_CODE PARTIC_OBJ_TYPE_CODE, OT.DISPLAY PARTIC_OBJ_TYPE_DISP, O.TAGLINE PARTICIPANT_NAME, TPIOR.DISPLAY OFFICE, I.SID INVOLV_SID, I.IS_PRI_SUBJECT FROM MV_PARTIC_INVOLVEMENT I INNER JOIN MV_PARTIC_ROLE_TYPE T ON I.INVOLVEMENT_ROLE = T.SID INNER JOIN MV_ACM_OBJ O ON I.PARTICIPANT = O.SID INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID LEFT JOIN MV_PARTIC_INDIV_OFFICE TPIO ON TPIO.SID = I.INDIV_OFFICE LEFT JOIN MV_PARTIC_INDIV_OFFICE_REF TPIOR ON TPIOR.REF_KEY = TPIO.OFFICE |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|